package com.fox0g.mapper;

import com.fox0g.pojo.Farm;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

import java.util.List;

/**
* @author 86176
* @description 针对表【farm(农业)】的数据库操作Mapper
* @createDate 2024-07-03 16:09:36
* @Entity com.fox0g.pojo.Farm
*/

@Mapper
public interface FarmMapper extends BaseMapper<Farm> {

    @Insert("insert into farm.farm( id,tstate,hstate,lsstate,create_time)" +
            " values (#{id},#{tstate},#{hstate},#{lsstate},#{createTime})")
    int insert(Farm farm) ;

    List<Farm> selectbytstate(@Param("begin") String begin,@Param("end") String end);


    List<Farm> selectbyhstate(@Param("begin") String begin,@Param("end") String end);


    List<Farm> selectbylsstate(@Param("begin") String begin,@Param("end") String end);

}




